CREATE TABLE tb_Scorecard(
	ScorecardId INT NOT NULL IDENTITY(1, 1),
	CourseId INT NOT NULL,
	PlayerId INT NOT NULL,
	Date SMALLDATETIME NOT NULL,
	CONSTRAINT PK_Scorecard PRIMARY KEY (ScorecardId),
	CONSTRAINT FK_Scorecard_Course FOREIGN KEY (CourseId)
		REFERENCES tb_Course (CourseId),
	CONSTRAINT FK_Scorecard_Player FOREIGN KEY (PlayerId)
		REFERENCES tb_Player (PlayerId))